#ifndef __OSA_SQLITE3_DB__
#define __OSA_SQLITE3_DB__

#include <Poco/Data/Common.h>
#include <Poco/Data/SQLite/Connector.h>
#include <string>

class sql_query {
	Poco::Data::Session sql;

	long long save_osa_setting(float start_wavelength, float stop_wavelength,
		float sensitivity, float resolution_bandwidth,unsigned trace_no);

public:
	sql_query();
	void sql_insert_description(std::string date, std::string description, 
		float start_wavelength, float stop_wavelength,
		float sensitivity, float resolution_bandwidth,unsigned trace_no);
	void sql_insert_trace(std::string date, float displacement_y, float* y, unsigned trace_length);
};

#endif
